# -*- coding: utf-8 -*-

"""
以下都是创建数据表的SQL语句，共有58个，都创建在同一个数据库“nba_database”中，DBMS——MySQL。
"""
# 1
player_brief_introduction = """
CREATE TABLE IF NOT EXISTS player_brief_introduction(
    bi_id  int  NOT NULL  AUTO_INCREMENT,
    bi_name  varchar(50)  NOT NULL,
    bi_fullname  varchar(50)  COMMENT '全名',
    bi_role  varchar(10)  COMMENT '位置',
    bi_height  varchar(20)  COMMENT '身高',
    bi_weight  varchar(20)  COMMENT '体重',
    bi_birthday  varchar(20)  COMMENT '出生日期',
    bi_city  varchar(50)  COMMENT '出生城市', 
    bi_highschool  varchar(50)  COMMENT '高中',
    bi_university  varchar(50)  COMMENT '大学',
    bi_jerseynumber  varchar(20)  COMMENT '球衣号码',
    bi_draftsituation  varchar(50)  COMMENT '选秀情况',
    bi_currentsalary  varchar(50)  COMMENT '当前薪金',
    bi_baidulink  varchar(50)  COMMENT '百度资料链接',
    bi_wikilink  varchar(50)  COMMENT '维基资料链接',
    PRIMARY KEY(bi_id)
    )ENGINE=InnoDB;
    
    """

# 2
player_season_average_data = """
CREATE TABLE IF NOT EXISTS player_season_average_data(
    sad_id  int  NOT NULL    AUTO_INCREMENT,
    sad_name  varchar(50)  NOT NULL,
    sad_season  varchar(20)  COMMENT '赛季',
    sad_team  varchar(50)  COMMENT '球队',
    sad_appearance  varchar(10)  COMMENT '出场',
    sad_starting  varchar(10)  COMMENT '首发',
    sad_time  varchar(10)  COMMENT '时间',
    sad_shot  varchar(10)  COMMENT '投篮',
    sad_shothit  varchar(10)  COMMENT '投篮命中',
    sad_shotto  varchar(10)  COMMENT '投篮出手',
    sad_threepoints  varchar(10)  COMMENT '三分',
    sad_tphit  varchar(10)  COMMENT '三分命中',
    sad_tpshot  varchar(10)  COMMENT '三分出手',
    sad_penalty  varchar(10)  COMMENT '罚球',
    sad_phit  varchar(10)  COMMENT '罚球命中',
    sad_pshot  varchar(10)  COMMENT '罚球出手',
    sad_backboard  varchar(10)  COMMENT '篮板',
    sad_bbfront  varchar(10)  COMMENT '前场篮板',
    sad_bbback  varchar(10)  COMMENT '后场篮板',
    sad_assist  varchar(10)  COMMENT '助攻',
    sad_steal  varchar(10)  COMMENT '抢断',
    sad_cap  varchar(10)  COMMENT '盖帽',
    sad_mistake  varchar(10)  COMMENT '失误',
    sad_foul  varchar(10)  COMMENT '犯规',
    sad_score  varchar(10)  COMMENT '得分',
    sad_win  varchar(10)  COMMENT '胜',
    sad_negative  varchar(10)  COMMENT '负',
    PRIMARY KEY(sad_id)
    )ENGINE=InnoDB;
    """

# 3
player_season_average_data_count = """
CREATE TABLE IF NOT EXISTS player_season_average_data_count(
    sadc_id  int  NOT NULL    AUTO_INCREMENT,
    sadc_name  varchar(50)  NOT NULL,
    sadc_nbacareer  varchar(20)  COMMENT 'NBA生涯',
    sadc_pftt  varchar(20)  COMMENT '效力球队',
    sadc_appearance  varchar(10)  COMMENT '出场',
    sadc_starting  varchar(10)  COMMENT '首发',
    sadc_avgtime  varchar(10)  COMMENT '场均时间',
    sadc_avgshot  varchar(10)  COMMENT '场均投篮',
    sadc_avgshit  varchar(10)  COMMENT '场均投篮命中',
    sadc_avgsshot  varchar(10)  COMMENT '场均投篮出手',
    sadc_avgthreep  varchar(10)  COMMENT '场均三分',
    sadc_avgtphit  varchar(10)  COMMENT '场均三分命中',
    sadc_avgtpshot  varchar(10)  COMMENT '场均三分出手',
    sadc_avgpenalty  varchar(10)  COMMENT '场均罚球',
    sadc_avgphit  varchar(10)  COMMENT '场均罚球命中',
    sadc_avgpshot  varchar(10)  COMMENT '场均罚球出手',
    sadc_avgbackboard  varchar(10)  COMMENT '场均篮板',
    sadc_avgbbfront  varchar(10)  COMMENT '场均前场篮板',
    sadc_avgbbback  varchar(10)  COMMENT '场均后场篮板',
    sadc_avgassist  varchar(10)  COMMENT '场均助攻',
    sadc_avgsteal  varchar(10)  COMMENT '场均抢断',
    sadc_avgcap  varchar(10)  COMMENT '场均盖帽',
    sadc_avgmistake  varchar(10)  COMMENT '场均失误',
    sadc_avgfoul  varchar(10)  COMMENT '场均犯规',
    sadc_avgscore  varchar(10)  COMMENT '场均得分',
    sadc_win  varchar(10)  COMMENT '胜',
    sadc_negative  varchar(10)  COMMENT '负',
    PRIMARY KEY(sadc_id)
    )ENGINE=InnoDB;
    """

# 4
player_season_total_data = """
CREATE TABLE IF NOT EXISTS player_season_total_data(
    std_id  int  NOT NULL    AUTO_INCREMENT,
    std_name varchar(50) NOT NULL,
    std_season varchar(20) COMMENT '赛季',
    std_team varchar(50) COMMENT '球队',
    std_appearance varchar(10) COMMENT '出场',
    std_starting varchar(10) COMMENT '首发',
    std_time varchar(10) COMMENT '时间',
    std_shot varchar(10) COMMENT '投篮',
    std_shothit varchar(10) COMMENT '投篮命中',
    std_shotto varchar(10) COMMENT '投篮出手',
    std_threepoints varchar(10) COMMENT '三分',
    std_tphit varchar(10) COMMENT '三分命中',
    std_tpshot varchar(10) COMMENT '三分出手',
    std_penalty varchar(10) COMMENT '罚球',
    std_phit varchar(10) COMMENT '罚球命中',
    std_pshot varchar(10) COMMENT '罚球出手',
    std_backboard varchar(10) COMMENT '篮板',
    std_bbfront varchar(10) COMMENT '前场篮板',
    std_bbback varchar(10) COMMENT '后场篮板',
    std_assist varchar(10) COMMENT '助攻',
    std_steal varchar(10) COMMENT '抢断',
    std_cap varchar(10) COMMENT '盖帽',
    std_mistake varchar(10) COMMENT '失误',
    std_foul varchar(10) COMMENT '犯规',
    std_score varchar(10) COMMENT '得分',
    std_win varchar(10) COMMENT '胜',
    std_negative varchar(10) COMMENT '负',
    PRIMARY KEY(std_id)
    )ENGINE=InnoDB;
"""

# 5
player_season_total_data_count = """
CREATE TABLE IF NOT EXISTS player_season_total_data_count(
    stdc_id  int  NOT NULL  AUTO_INCREMENT,
    stdc_name  varchar(50)  NOT NULL,
    stdc_nbacareer  varchar(20)  COMMENT 'NBA生涯',
    stdc_pftt  varchar(20)  COMMENT '效力球队',
    stdc_appearance  varchar(10)  COMMENT '出场',
    stdc_starting  varchar(10)  COMMENT '首发',
    stdc_totaltime  varchar(10)  COMMENT '总计时间',
    stdc_totalshot  varchar(10)  COMMENT '总计投篮',
    stdc_totalshit  varchar(10)  COMMENT '总计投篮命中',
    stdc_totalsshot  varchar(10)  COMMENT '总计投篮出手',
    stdc_totalthreep  varchar(10)  COMMENT '总计三分',
    stdc_totaltphit  varchar(10)  COMMENT '总计三分命中',
    stdc_totaltpshot  varchar(10)  COMMENT '总计三分出手',
    stdc_totalpenalty  varchar(10)  COMMENT '总计罚球',
    stdc_totalphit  varchar(10)  COMMENT '总计罚球命中',
    stdc_totalpshot  varchar(10)  COMMENT '总计罚球出手',
    stdc_totalbackboard  varchar(10)  COMMENT '总计篮板',
    stdc_totalbbfront  varchar(10)  COMMENT '总计前场篮板',
    stdc_totalbbback  varchar(10)  COMMENT '总计后场篮板',
    stdc_totalassist  varchar(10)  COMMENT '总计助攻',
    stdc_totalsteal  varchar(10)  COMMENT '总计抢断',
    stdc_totalcap  varchar(10)  COMMENT '总计盖帽',
    stdc_totalmistake  varchar(10)  COMMENT '总计失误',
    stdc_totalfoul  varchar(10)  COMMENT '总计犯规',
    stdc_totalscore  varchar(10)  COMMENT '总计得分',
    stdc_win  varchar(10)  COMMENT '胜',
    stdc_negative  varchar(10)  COMMENT '负',
    PRIMARY KEY(stdc_id)
    )ENGINE=InnoDB;
"""

# 6
player_season_best_data = """
CREATE TABLE IF NOT EXISTS player_season_best_data(
    sbd_id  int  NOT NULL    AUTO_INCREMENT,
    sbd_name  varchar(50)  NOT NULL,
    sbd_season  varchar(20)  COMMENT '赛季',
    sbd_team  varchar(50)  COMMENT '球队',
    sbd_time  varchar(10)  COMMENT '时间',
    sbd_shot  varchar(10)  COMMENT '投篮',
    sbd_shothit  varchar(10)  COMMENT '投篮命中',
    sbd_shotto  varchar(10)  COMMENT '投篮出手',
    sbd_threepoints  varchar(10)  COMMENT '三分',
    sbd_tphit  varchar(10)  COMMENT '三分命中',
    sbd_tpshot  varchar(10)  COMMENT '三分出手',
    sbd_penalty  varchar(10)  COMMENT '罚球',
    sbd_phit  varchar(10)  COMMENT '罚球命中',
    sbd_pshot  varchar(10)  COMMENT '罚球出手',
    sbd_backboard  varchar(10)  COMMENT '篮板',
    sbd_bbfront  varchar(10)  COMMENT '前场篮板',
    sbd_bbback  varchar(10)  COMMENT '后场篮板',
    sbd_assist  varchar(10)  COMMENT '助攻',
    sbd_steal  varchar(10)  COMMENT '抢断',
    sbd_cap  varchar(10)  COMMENT '盖帽',
    sbd_mistake  varchar(10)  COMMENT '失误',
    sbd_foul  varchar(10)  COMMENT '犯规',
    sbd_score  varchar(10)  COMMENT '得分',
    PRIMARY KEY(sbd_id)
    )ENGINE=InnoDB;
"""

# 7
player_season_best_data_count = """
CREATE TABLE IF NOT EXISTS player_season_best_data_count(
    sbdc_id  int  NOT NULL  AUTO_INCREMENT,
    sbdc_name  varchar(50)  NOT NULL,
    sbdc_nbacareer  varchar(20)  COMMENT 'NBA生涯',
    sbdc_pftt  varchar(20)  COMMENT '效力球队',
    sbdc_besttime  varchar(10)  COMMENT '单场最高时间',
    sbdc_bestshot  varchar(10)  COMMENT '单场最高投篮',
    sbdc_bestshit  varchar(10)  COMMENT '单场最高投篮命中',
    sbdc_bestsshot  varchar(10)  COMMENT '单场最高投篮出手',
    sbdc_bestthreep  varchar(10)  COMMENT '单场最高三分',
    sbdc_besttphit  varchar(10)  COMMENT '单场最高三分命中',
    sbdc_besttpshot  varchar(10)  COMMENT '单场最高三分出手',
    sbdc_bestpenalty  varchar(10)  COMMENT '单场最高罚球',
    sbdc_bestphit  varchar(10)  COMMENT '单场最高罚球命中',
    sbdc_bestpshot  varchar(10)  COMMENT '单场最高罚球出手',
    sbdc_bestbackboard  varchar(10)  COMMENT '单场最高篮板',
    sbdc_bestbbfront  varchar(10)  COMMENT '单场最高前场篮板',
    sbdc_bestbbback  varchar(10)  COMMENT '单场最高后场篮板',
    sbdc_bestassist  varchar(10)  COMMENT '单场最高助攻',
    sbdc_beststeal  varchar(10)  COMMENT '单场最高抢断',
    sbdc_bestcap varchar(10)  COMMENT '单场最高盖帽',
    sbdc_bestmistake  varchar(10)  COMMENT '单场最高失误',
    sbdc_bestfoul varchar(10)  COMMENT '单场最高犯规',
    sbdc_bestscore  varchar(10)  COMMENT '单场最高得分',
    PRIMARY KEY(sbdc_id)
    )ENGINE=InnoDB;
"""

# 8
player_season_advanced_data_base = """
CREATE TABLE IF NOT EXISTS player_season_advanced_data_base(
    sadb_id  int  NOT NULL    AUTO_INCREMENT,
    sadb_name  varchar(50)  NOT NULL,
    sadb_season  varchar(10)  COMMENT '赛季',
    sadb_team  varchar(20)  COMMENT '球队',
    sadb_reboundrate  varchar(10)  COMMENT '篮板率',
    sadb_offensiveboard  varchar(10)  COMMENT '进攻板篮板率',
    sadb_defensiveboard  varchar(10)  COMMENT '防守板篮板率',
    sadb_assistrate  varchar(10)  COMMENT '助攻率',
    sadb_stealrate  varchar(10)  COMMENT '抢断率',
    sadb_blockrate  varchar(10)  COMMENT '盖帽率',
    sadb_errorrate  varchar(10)  COMMENT '失误率',
    sadb_usagerate  varchar(10)  COMMENT '使用率',
    sadb_offeneffi  varchar(10)  COMMENT '进攻效率',
    sadb_defeneffi  varchar(10)  COMMENT '防守效率',
    sadb_ws  varchar(10),
    sadb_offenws  varchar(10)  COMMENT '进攻ws',
    sadb_defenws  varchar(10)  COMMENT '防守ws',
    sadb_per  varchar(10)  COMMENT 'PER',
    sadb_dunk  varchar(10)  COMMENT '扣篮',
    sadb_addone  varchar(10)  COMMENT '2/3+1',
    PRIMARY KEY(sadb_id)
    )ENGINE=InnoDB;
"""

# 9
player_season_advanced_data_base_count = """
CREATE TABLE IF NOT EXISTS player_season_advanced_data_base_count(
    sadbc_id  int  NOT NULL  AUTO_INCREMENT,
    sadbc_name  varchar(50)  NOT NULL,
    sadbc_season  varchar(10)  COMMENT '赛季',
    sadbc_team  varchar(20)  COMMENT '球队',
    sadbc_advreboudrate  varchar(10)  COMMENT '进阶篮板率',
    sadbc_advoffenboard  varchar(10)  COMMENT '进阶进攻板',
    sadbc_advdefenboard  varchar(10)  COMMENT '进阶防守板',
    sadbc_advassistrate  varchar(10)  COMMENT '进阶助攻率',
    sadbc_advstealrate  varchar(10)  COMMENT '进阶抢断率',
    sadbc_advblockrate  varchar(10)  COMMENT '进阶盖帽率',
    sadbc_adverrorrate  varchar(10)  COMMENT '进阶失误率',
    sadbc_advusagerate  varchar(10)  COMMENT '进阶使用率',
    sadbc_advoffeneffic  varchar(10)  COMMENT '进阶进攻效率',
    sadbc_advdefeneffic  varchar(10)  COMMENT '进阶防守效率',
    sadbc_advws  varchar(10)  COMMENT '进阶WS',
    sadbc_advoffenws  varchar(10)  COMMENT '进阶进攻WS',
    sadbc_advdefenws  varchar(10)  COMMENT '进阶防守WS',
    sadbc_advper  varchar(10)  COMMENT '进阶PER',
    sadbc_advdunk  varchar(10)  COMMENT '进阶扣篮',
    sadbc_advaddone  varchar(10)  COMMENT '进阶2/3+1',
    PRIMARY KEY(sadbc_id)
    )ENGINE=InnoDB;
"""

# 10
player_season_advanced_data_shooting = """
CREATE TABLE IF NOT EXISTS player_season_advanced_data_shooting(
    sads_id  int  NOT NULL  AUTO_INCREMENT,
    sads_name  varchar(50)  NOT NULL,
    sads_season  varchar(10)  COMMENT '赛季',
    sads_team  varchar(20)  COMMENT '球队',
    sads_shotdistance  varchar(10)  COMMENT '出手距离',
    sads_bhitrate  varchar(10)  COMMENT '篮下命中率',
    sads_bhit  varchar(10)  COMMENT '篮下命中',
    sads_bshot  varchar(10)  COMMENT '篮下出手',
    sads_bpercentage  varchar(10)  COMMENT '篮下占比',
    sads_closetps  varchar(10)  COMMENT '近距离两分',
    sads_ctpshit  varchar(10)  COMMENT '近距离两分命中',
    sads_ctpsshot  varchar(10)  COMMENT '近距离两分出手',
    sads_ctpsperc  varchar(10)  COMMENT '近距离两分占比',
    sads_middletps  varchar(10)  COMMENT '中距离两分',
    sads_mtpshit  varchar(10)  COMMENT '中距离两分命中',
    sads_mtpsshot  varchar(10)  COMMENT '中距离两分出手',
    sads_mtpsperc  varchar(10)  COMMENT '中距离两分占比',
    sads_longtps  varchar(10)  COMMENT '远距离两分',
    sads_ltpshit  varchar(10)  COMMENT '远距离两分命中',
    sads_ltpsshot  varchar(10)  COMMENT '远距离两分出手',
    sads_ltpsperc  varchar(10)  COMMENT '远距离两分占比',
    sads_truehitrate  varchar(10)  COMMENT '真实命中率',
    sads_shooteffic  varchar(10)  COMMENT '投篮效率',
    PRIMARY KEY(sads_id)
    )ENGINE=InnoDB;
"""

# 11
player_season_advanced_data_shooting_count = """
CREATE TABLE IF NOT EXISTS player_season_advanced_data_shooting_count(
    sadsc_id  int  NOT NULL  AUTO_INCREMENT,
    sadsc_name  varchar(50)  NOT NULL,
    sadsc_season  varchar(10)  COMMENT '赛季',
    sadsc_team  varchar(20)  COMMENT '球队',
    sadsc_advshotdistance  varchar(10)  COMMENT '进阶出手距离',
    sadsc_advbaskethitrate  varchar(10)  COMMENT '进阶篮下命中率',
    sadsc_advbhrhit  varchar(10)  COMMENT '进阶篮下命中',
    sadsc_advbhrshot  varchar(10)  COMMENT '进阶篮下出手',
    sadsc_advpbhrperc  varchar(10)  COMMENT '进阶篮下占比',
    sadsc_advclosetwop  varchar(10)  COMMENT '进阶近距离两分',
    sadsc_advctphit  varchar(10)  COMMENT '进阶近距离两分命中',
    sadsc_advctpshot  varchar(10)  COMMENT '进阶近距离两分出手',
    sadsc_advctpperc  varchar(10)  COMMENT '进阶近距离两分占比',
    sadsc_advmiddletwop  varchar(10)  COMMENT '进阶中距离两分',
    sadsc_advmtphit varchar(10)  COMMENT '进阶中距离两分命中',
    sadsc_advmtpshot  varchar(10)  COMMENT '进阶中距离两分出手',
    sadsc_advmtpperc  varchar(10)  COMMENT '进阶中距离两分占比',
    sadsc_advlongtwop  varchar(10)  COMMENT '进阶远距离两分',
    sadsc_advltphit  varchar(10)  COMMENT '进阶远距离两分命中',
    sadsc_advltpshot  varchar(10)  COMMENT '进阶远距离两分出手',
    sadsc_advltpperc  varchar(10)  COMMENT '进阶远距离两分占比',
    sadsc_advtruehitrate  varchar(10)  COMMENT '进阶真实命中率',
    sadsc_advshooteffic  varchar(10)  COMMENT '进阶投篮效率',
    PRIMARY KEY(sadsc_id)
    )ENGINE=InnoDB;
"""

# 12
player_playoff_average_data = """
CREATE TABLE IF NOT EXISTS player_playoff_average_data(
    pad_id  int  NOT NULL    AUTO_INCREMENT,
    pad_name  varchar(50)  NOT NULL,
    pad_season  varchar(20)   COMMENT '赛季',
    pad_team  varchar(50)   COMMENT '球队',
    pad_appearance  varchar(10)   COMMENT '出场',
    pad_time  varchar(10)   COMMENT '时间',
    pad_shot  varchar(10)   COMMENT '投篮',
    pad_shothit  varchar(10)   COMMENT '投篮命中',
    pad_shotto  varchar(10)   COMMENT '投篮出手',
    pad_threepoints  varchar(10)   COMMENT '三分',
    pad_tphit  varchar(10)   COMMENT '三分命中',
    pad_tpshot  varchar(10)   COMMENT '三分出手',
    pad_penalty  varchar(10)   COMMENT '罚球',
    pad_phit  varchar(10)   COMMENT '罚球命中',
    pad_pshot  varchar(10)   COMMENT '罚球出手',
    pad_backboard  varchar(10)   COMMENT '篮板',
    pad_bbfront  varchar(10)   COMMENT '前场篮板',
    pad_bbback  varchar(10)   COMMENT '后场篮板',
    pad_assist  varchar(10)   COMMENT '助攻',
    pad_steal  varchar(10)   COMMENT '抢断',
    pad_cap  varchar(10)   COMMENT '盖帽',
    pad_mistake  varchar(10)   COMMENT '失误',
    pad_foul  varchar(10)   COMMENT '犯规',
    pad_score  varchar(10)   COMMENT '得分',
    pad_win  varchar(10)   COMMENT '胜',
    pad_negative  varchar(10)   COMMENT '负',
    PRIMARY KEY(pad_id)
    )ENGINE=InnoDB;
"""

# 13
player_playoff_average_data_count = """
CREATE TABLE IF NOT EXISTS player_playoff_average_data_count(
    padc_id  int  NOT NULL    AUTO_INCREMENT,
    padc_name  varchar(50)  NOT NULL,
    padc_nbacareer  varchar(20)  COMMENT 'NBA生涯',
    padc_pftt  varchar(20)  COMMENT '效力球队',
    padc_appearance  varchar(10)  COMMENT '出场',
    padc_avgtime  varchar(10)  COMMENT '场均时间',
    padc_avgshot  varchar(10)  COMMENT '场均投篮',
    padc_avgshit  varchar(10)  COMMENT '场均投篮命中',
    padc_avgsshot  varchar(10)  COMMENT '场均投篮出手',
    padc_avgthreep  varchar(10)  COMMENT '场均三分',
    padc_avgtphit  varchar(10)  COMMENT '场均三分命中',
    padc_avgtpshot  varchar(10)  COMMENT '场均三分出手',
    padc_avgpenalty  varchar(10)  COMMENT '场均罚球',
    padc_avgphit  varchar(10)  COMMENT '场均罚球命中',
    padc_avgpshot  varchar(10)  COMMENT '场均罚球出手',
    padc_avgbackboard  varchar(10)  COMMENT '场均篮板',
    padc_avgbbfront  varchar(10)  COMMENT '场均前场篮板',
    padc_avgbbback  varchar(10)  COMMENT '场均后场篮板',
    padc_avgassist  varchar(10)  COMMENT '场均助攻',
    padc_avgsteal  varchar(10)  COMMENT '场均抢断',
    padc_avgcap  varchar(10)  COMMENT '场均盖帽',
    padc_avgmistake  varchar(10)  COMMENT '场均失误',
    padc_avgfoul  varchar(10)  COMMENT '场均犯规',
    padc_avgscore  varchar(10)  COMMENT '场均得分',
    padc_win  varchar(10)  COMMENT '胜',
    padc_negative  varchar(10)  COMMENT '负',
    PRIMARY KEY(padc_id)
    )ENGINE=InnoDB;
"""

# 14
player_playoff_total_data = """
CREATE TABLE IF NOT EXISTS player_playoff_total_data(
    ptd_id  int  NOT NULL    AUTO_INCREMENT,
    ptd_name varchar(50) NOT NULL,
    ptd_season varchar(20) COMMENT '赛季',
    ptd_team varchar(50) COMMENT '球队',
    ptd_appearance varchar(10) COMMENT '出场',
    ptd_time varchar(10) COMMENT '时间',
    ptd_shot varchar(10) COMMENT '投篮',
    ptd_shothit varchar(10) COMMENT '投篮命中',
    ptd_shotto varchar(10) COMMENT '投篮出手',
    ptd_threepoints varchar(10) COMMENT '三分',
    ptd_tphit varchar(10) COMMENT '三分命中',
    ptd_tpshot varchar(10) COMMENT '三分出手',
    ptd_penalty varchar(10) COMMENT '罚球',
    ptd_phit varchar(10) COMMENT '罚球命中',
    ptd_pshot varchar(10) COMMENT '罚球出手',
    ptd_backboard varchar(10) COMMENT '篮板',
    ptd_bbfront varchar(10) COMMENT '前场篮板',
    ptd_bbback varchar(10) COMMENT '后场篮板',
    ptd_assist varchar(10) COMMENT '助攻',
    ptd_steal varchar(10) COMMENT '抢断',
    ptd_cap varchar(10) COMMENT '盖帽',
    ptd_mistake varchar(10) COMMENT '失误',
    ptd_foul varchar(10) COMMENT '犯规',
    ptd_score varchar(10) COMMENT '得分',
    ptd_win varchar(10) COMMENT '胜',
    ptd_negative varchar(10) COMMENT '负',
    PRIMARY KEY(ptd_id)
    )ENGINE=InnoDB;
"""

# 15
player_playoff_total_data_count = """
CREATE TABLE IF NOT EXISTS player_playoff_total_data_count(
    ptdc_id  int  NOT NULL  AUTO_INCREMENT,
    ptdc_name  varchar(50)  NOT NULL,
    ptdc_nbacareer  varchar(20)  COMMENT 'NBA生涯',
    ptdc_pftt  varchar(20)  COMMENT '效力球队',
    ptdc_appearance  varchar(10)  COMMENT '出场',
    ptdc_totaltime  varchar(10)  COMMENT '总计时间',
    ptdc_totalshot  varchar(10)  COMMENT '总计投篮',
    ptdc_totalshit  varchar(10)  COMMENT '总计投篮命中',
    ptdc_totalsshot  varchar(10)  COMMENT '总计投篮出手',
    ptdc_totalthreep  varchar(10)  COMMENT '总计三分',
    ptdc_totaltphit  varchar(10)  COMMENT '总计三分命中',
    ptdc_totaltpshot  varchar(10)  COMMENT '总计三分出手',
    ptdc_totalpenalty  varchar(10)  COMMENT '总计罚球',
    ptdc_totalphit  varchar(10)  COMMENT '总计罚球命中',
    ptdc_totalpshot  varchar(10)  COMMENT '总计罚球出手',
    ptdc_totalbackboard  varchar(10)  COMMENT '总计篮板',
    ptdc_totalbbfront  varchar(10)  COMMENT '总计前场篮板',
    ptdc_totalbbback  varchar(10)  COMMENT '总计后场篮板',
    ptdc_totalassist  varchar(10)  COMMENT '总计助攻',
    ptdc_totalsteal  varchar(10)  COMMENT '总计抢断',
    ptdc_totalcap  varchar(10)  COMMENT '总计盖帽',
    ptdc_totalmistake  varchar(10)  COMMENT '总计失误',
    ptdc_totalfoul  varchar(10)  COMMENT '总计犯规',
    ptdc_totalscore  varchar(10)  COMMENT '总计得分',
    ptdc_win  varchar(10)  COMMENT '胜',
    ptdc_negative  varchar(10)  COMMENT '负',
    PRIMARY KEY(ptdc_id)
    )ENGINE=InnoDB;
"""

# 16
player_playoff_best_data = """
CREATE TABLE IF NOT EXISTS player_playoff_best_data(
    pbd_id  int  NOT NULL    AUTO_INCREMENT,
    pbd_name  varchar(50)  NOT NULL,
    pbd_season  varchar(20)  COMMENT '赛季',
    pbd_team  varchar(50)  COMMENT '球队',
    pbd_time  varchar(10)  COMMENT '时间',
    pbd_shot  varchar(10)  COMMENT '投篮',
    pbd_shothit  varchar(10)  COMMENT '投篮命中',
    pbd_shotto  varchar(10)  COMMENT '投篮出手',
    pbd_threepoints  varchar(10)  COMMENT '三分',
    pbd_tphit  varchar(10)  COMMENT '三分命中',
    pbd_tpshot  varchar(10)  COMMENT '三分出手',
    pbd_penalty  varchar(10)  COMMENT '罚球',
    pbd_phit  varchar(10)  COMMENT '罚球命中',
    pbd_pshot  varchar(10)  COMMENT '罚球出手',
    pbd_backboard  varchar(10)  COMMENT '篮板',
    pbd_bbfront  varchar(10)  COMMENT '前场篮板',
    pbd_bbback  varchar(10)  COMMENT '后场篮板',
    pbd_assist  varchar(10)  COMMENT '助攻',
    pbd_steal  varchar(10)  COMMENT '抢断',
    pbd_cap  varchar(10)  COMMENT '盖帽',
    pbd_mistake  varchar(10)  COMMENT '失误',
    pbd_foul  varchar(10)  COMMENT '犯规',
    pbd_score  varchar(10)  COMMENT '得分',
    PRIMARY KEY(pbd_id)
    )ENGINE=InnoDB;
"""

# 17
player_playoff_best_data_count = """
CREATE TABLE IF NOT EXISTS player_playoff_best_data_count(
    pbdc_id  int  NOT NULL  AUTO_INCREMENT,
    pbdc_name  varchar(50)  NOT NULL,
    pbdc_season  varchar(20)  COMMENT '赛季',
    pbdc_team  varchar(50)  COMMENT '球队',
    pbdc_besttime  varchar(10)  COMMENT '单场最高时间',
    pbdc_bestshot  varchar(10)  COMMENT '单场最高投篮',
    pbdc_bestshit  varchar(10)  COMMENT '单场最高投篮命中',
    pbdc_bestsshot  varchar(10)  COMMENT '单场最高投篮出手',
    pbdc_bestthreep  varchar(10)  COMMENT '单场最高三分',
    pbdc_besttphit  varchar(10)  COMMENT '单场最高三分命中',
    pbdc_besttpshot  varchar(10)  COMMENT '单场最高三分出手',
    pbdc_bestpenalty  varchar(10)  COMMENT '单场最高罚球',
    pbdc_bestphit  varchar(10)  COMMENT '单场最高罚球命中',
    pbdc_bestpshot  varchar(10)  COMMENT '单场最高罚球出手',
    pbdc_bestbackboard  varchar(10)  COMMENT '单场最高篮板',
    pbdc_bestbbfront  varchar(10)  COMMENT '单场最高前场篮板',
    pbdc_bestbbback  varchar(10)  COMMENT '单场最高后场篮板',
    pbdc_bestassist  varchar(10)  COMMENT '单场最高助攻',
    pbdc_beststeal  varchar(10)  COMMENT '单场最高抢断',
    pbdc_bestcap varchar(10)  COMMENT '单场最高盖帽',
    pbdc_bestmistake  varchar(10)  COMMENT '单场最高失误',
    pbdc_bestfoul varchar(10)  COMMENT '单场最高犯规',
    pbdc_bestscore  varchar(10)  COMMENT '单场最高得分',
    PRIMARY KEY(pbdc_id)
    )ENGINE=InnoDB;
"""

# 18
player_playoff_advanced_data_base = """
CREATE TABLE IF NOT EXISTS player_playoff_advanced_data_base(
    padb_id  int  NOT NULL    AUTO_INCREMENT,
    padb_name  varchar(50)  NOT NULL,
    padb_season  varchar(10)  COMMENT '赛季',
    padb_team  varchar(50)  COMMENT '球队',
    padb_reboundrate  varchar(10)  COMMENT '篮板率',
    padb_offensiveboard  varchar(10)  COMMENT '进攻板篮板率',
    padb_defensiveboard  varchar(10)  COMMENT '防守板篮板率',
    padb_assistrate  varchar(10)  COMMENT '助攻率',
    padb_stealrate  varchar(10)  COMMENT '抢断率',
    padb_blockrate  varchar(10)  COMMENT '盖帽率',
    padb_errorrate  varchar(10)  COMMENT '失误率',
    padb_usagerate  varchar(10)  COMMENT '使用率',
    padb_offeneffi  varchar(10)  COMMENT '进攻效率',
    padb_defeneffi  varchar(10)  COMMENT '防守效率',
    padb_ws  varchar(10),
    padb_offenws  varchar(10)  COMMENT '进攻ws',
    padb_defenws  varchar(10)  COMMENT '防守ws',
    padb_per  varchar(10)  COMMENT 'PER',
    padb_dunk  varchar(10)  COMMENT '扣篮',
    padb_addone  varchar(10)  COMMENT '2/3+1',
    PRIMARY KEY(padb_id)
    )ENGINE=InnoDB;
"""

# 19
player_playoff_advanced_data_base_count = """
CREATE TABLE IF NOT EXISTS player_playoff_advanced_data_base_count(
    padbc_id  int  NOT NULL  AUTO_INCREMENT,
    padbc_name  varchar(50)  NOT NULL,
    padbc_season  varchar(10)  COMMENT '赛季',
    padbc_team  varchar(50)  COMMENT '球队',
    padbc_advreboudrate  varchar(10)  COMMENT '进阶篮板率',
    padbc_advoffenboard  varchar(10)  COMMENT '进阶进攻板',
    padbc_advdefenboard  varchar(10)  COMMENT '进阶防守板',
    padbc_advassistrate  varchar(10)  COMMENT '进阶助攻率',
    padbc_advstealrate  varchar(10)  COMMENT '进阶抢断率',
    padbc_advblockrate  varchar(10)  COMMENT '进阶盖帽率',
    padbc_adverrorrate  varchar(10)  COMMENT '进阶失误率',
    padbc_advusagerate  varchar(10)  COMMENT '进阶使用率',
    padbc_advoffeneffic  varchar(10)  COMMENT '进阶进攻效率',
    padbc_advdefeneffic  varchar(10)  COMMENT '进阶防守效率',
    padbc_advws  varchar(10)  COMMENT '进阶WS',
    padbc_advoffenws  varchar(10)  COMMENT '进阶进攻WS',
    padbc_advdefenws  varchar(10)  COMMENT '进阶防守WS',
    padbc_advper  varchar(10)  COMMENT '进阶PER',
    padbc_advdunk  varchar(10)  COMMENT '进阶扣篮',
    padbc_advaddone  varchar(10)  COMMENT '进阶2/3+1',
    PRIMARY KEY(padbc_id)
    )ENGINE=InnoDB;
"""

# 20
player_playoff_advanced_data_shooting = """
CREATE TABLE IF NOT EXISTS player_playoff_advanced_data_shooting(
    pads_id  int  NOT NULL  AUTO_INCREMENT,
    pads_name  varchar(50)  NOT NULL,
    pads_season  varchar(10)  COMMENT '赛季',
    pads_team  varchar(50)  COMMENT '球队',
    pads_shotdistance  varchar(10)  COMMENT '出手距离',
    pads_bhitrate  varchar(10)  COMMENT '篮下命中率',
    pads_bhit  varchar(10)  COMMENT '篮下命中',
    pads_bshot  varchar(10)  COMMENT '篮下出手',
    pads_bpercentage  varchar(10)  COMMENT '篮下占比',
    pads_closetps  varchar(10)  COMMENT '近距离两分',
    pads_ctpshit  varchar(10)  COMMENT '近距离两分命中',
    pads_ctpsshot  varchar(10)  COMMENT '近距离两分出手',
    pads_ctpsperc  varchar(10)  COMMENT '近距离两分占比',
    pads_middletps  varchar(10)  COMMENT '中距离两分',
    pads_mtpshit  varchar(10)  COMMENT '中距离两分命中',
    pads_mtpsshot  varchar(10)  COMMENT '中距离两分出手',
    pads_mtpsperc  varchar(10)  COMMENT '中距离两分占比',
    pads_longtps  varchar(10)  COMMENT '远距离两分',
    pads_ltpshit  varchar(10)  COMMENT '远距离两分命中',
    pads_ltpsshot  varchar(10)  COMMENT '远距离两分出手',
    pads_ltpsperc  varchar(10)  COMMENT '远距离两分占比',
    pads_truehitrate  varchar(10)  COMMENT '真实命中率',
    pads_shooteffic  varchar(10)  COMMENT '投篮效率',
    PRIMARY KEY(pads_id)
    )ENGINE=InnoDB;
"""

# 21
player_playoff_advanced_data_shooting_count = """
CREATE TABLE IF NOT EXISTS player_playoff_advanced_data_shooting_count(
    padsc_id  int  NOT NULL  AUTO_INCREMENT,
    padsc_name  varchar(50)  NOT NULL,
    padsc_season  varchar(10)  COMMENT '赛季',
    padsc_team  varchar(50)  COMMENT '球队',
    padsc_advshotdistance  varchar(10)  COMMENT '进阶出手距离',
    padsc_advbaskethitrate  varchar(10)  COMMENT '进阶篮下命中率',
    padsc_advbhrhit  varchar(10)  COMMENT '进阶篮下命中',
    padsc_advbhrshot  varchar(10)  COMMENT '进阶篮下出手',
    padsc_advpbhrperc  varchar(10)  COMMENT '进阶篮下占比',
    padsc_advclosetwop  varchar(10)  COMMENT '进阶近距离两分',
    padsc_advctphit  varchar(10)  COMMENT '进阶近距离两分命中',
    padsc_advctpshot  varchar(10)  COMMENT '进阶近距离两分出手',
    padsc_advctpperc  varchar(10)  COMMENT '进阶近距离两分占比',
    padsc_advmiddletwop  varchar(10)  COMMENT '进阶中距离两分',
    padsc_advmtphit varchar(10)  COMMENT '进阶中距离两分命中',
    padsc_advmtpshot  varchar(10)  COMMENT '进阶中距离两分出手',
    padsc_advmtpperc  varchar(10)  COMMENT '进阶中距离两分占比',
    padsc_advlongtwop  varchar(10)  COMMENT '进阶远距离两分',
    padsc_advltphit  varchar(10)  COMMENT '进阶远距离两分命中',
    padsc_advltpshot  varchar(10)  COMMENT '进阶远距离两分出手',
    padsc_advltpperc  varchar(10)  COMMENT '进阶远距离两分占比',
    padsc_advtruehitrate  varchar(10)  COMMENT '进阶真实命中率',
    padsc_advshooteffic  varchar(10)  COMMENT '进阶投篮效率',
    PRIMARY KEY(padsc_id)
    )ENGINE=InnoDB;
"""

# 22
player_allstar_base_data = """
CREATE TABLE IF NOT EXISTS player_allstar_base_data(
    abd_id  int  NOT NULL    AUTO_INCREMENT,
    abd_name  varchar(50)  NOT NULL,
    abd_season  varchar(20)  COMMENT '赛季',
    abd_team  varchar(50)  COMMENT '球队',
    abd_starting  varchar(10)  COMMENT '首发',
    abd_time  varchar(10)  COMMENT '时间',
    abd_shot  varchar(10)  COMMENT '投篮',
    abd_shothit  varchar(10)  COMMENT '投篮命中',
    abd_shotto  varchar(10)  COMMENT '投篮出手',
    abd_threepoints  varchar(10)  COMMENT '三分',
    abd_tphit  varchar(10)  COMMENT '三分命中',
    abd_tpshot  varchar(10)  COMMENT '三分出手',
    abd_penalty  varchar(10)  COMMENT '罚球',
    abd_phit  varchar(10)  COMMENT '罚球命中',
    abd_pshot  varchar(10)  COMMENT '罚球出手',
    abd_backboard  varchar(10)  COMMENT '篮板',
    abd_bbfront  varchar(10)  COMMENT '前场篮板',
    abd_bbback  varchar(10)  COMMENT '后场篮板',
    abd_assist  varchar(10)  COMMENT '助攻',
    abd_steal  varchar(10)  COMMENT '抢断',
    abd_cap  varchar(10)  COMMENT '盖帽',
    abd_mistake  varchar(10)  COMMENT '失误',
    abd_foul  varchar(10)  COMMENT '犯规',
    abd_score  varchar(10)  COMMENT '得分',
    PRIMARY KEY(abd_id)
    )ENGINE=InnoDB;
"""

# 23
player_allstar_average_data = """
CREATE TABLE IF NOT EXISTS player_allstar_average_data(
    aad_id  int  NOT NULL    AUTO_INCREMENT,
    aad_name  varchar(50)  NOT NULL,
    aad_pftt  varchar(50)  COMMENT '效力球队',
    aad_starting  varchar(10)  COMMENT '首发',
    aad_time  varchar(10)  COMMENT '时间',
    aad_shot  varchar(10)  COMMENT '投篮',
    aad_shothit  varchar(10)  COMMENT '投篮命中',
    aad_shotto  varchar(10)  COMMENT '投篮出手',
    aad_threepoints  varchar(10)  COMMENT '三分',
    aad_tphit  varchar(10)  COMMENT '三分命中',
    aad_tpshot  varchar(10)  COMMENT '三分出手',
    aad_penalty  varchar(10)  COMMENT '罚球',
    aad_phit  varchar(10)  COMMENT '罚球命中',
    aad_pshot  varchar(10)  COMMENT '罚球出手',
    aad_backboard  varchar(10)  COMMENT '篮板',
    aad_bbfront  varchar(10)  COMMENT '前场篮板',
    aad_bbback  varchar(10)  COMMENT '后场篮板',
    aad_assist  varchar(10)  COMMENT '助攻',
    aad_steal  varchar(10)  COMMENT '抢断',
    aad_cap  varchar(10)  COMMENT '盖帽',
    aad_mistake  varchar(10)  COMMENT '失误',
    aad_foul  varchar(10)  COMMENT '犯规',
    aad_score  varchar(10)  COMMENT '得分',
    PRIMARY KEY(aad_id)
    )ENGINE=InnoDB;
"""

# 24
player_allstar_total_data = """
CREATE TABLE IF NOT EXISTS player_allstar_total_data(
    atd_id  int  NOT NULL    AUTO_INCREMENT,
    atd_name  varchar(50)  NOT NULL,
    atd_pftt  varchar(50)  COMMENT '效力球队',
    atd_starting  varchar(10)  COMMENT '首发',
    atd_time  varchar(10)  COMMENT '时间',
    atd_shot  varchar(10)  COMMENT '投篮',
    atd_shothit  varchar(10)  COMMENT '投篮命中',
    atd_shotto  varchar(10)  COMMENT '投篮出手',
    atd_threepoints  varchar(10)  COMMENT '三分',
    atd_tphit  varchar(10)  COMMENT '三分命中',
    atd_tpshot  varchar(10)  COMMENT '三分出手',
    atd_penalty  varchar(10)  COMMENT '罚球',
    atd_phit  varchar(10)  COMMENT '罚球命中',
    atd_pshot  varchar(10)  COMMENT '罚球出手',
    atd_backboard  varchar(10)  COMMENT '篮板',
    atd_bbfront  varchar(10)  COMMENT '前场篮板',
    atd_bbback  varchar(10)  COMMENT '后场篮板',
    atd_assist  varchar(10)  COMMENT '助攻',
    atd_steal  varchar(10)  COMMENT '抢断',
    atd_cap  varchar(10)  COMMENT '盖帽',
    atd_mistake  varchar(10)  COMMENT '失误',
    atd_foul  varchar(10)  COMMENT '犯规',
    atd_score  varchar(10)  COMMENT '得分',
    PRIMARY KEY(atd_id)
    )ENGINE=InnoDB;
"""

# 25
player_season_score_list = """
CREATE TABLE IF NOT EXISTS player_season_score_list(
    scl_id  int  NOT NULL    AUTO_INCREMENT,
    scl_name  varchar(50)  NOT NULL,
    scl_match  varchar(20)  COMMENT '得分榜比赛',
    scl_score  varchar(10)  COMMENT '得分榜得分',
    PRIMARY KEY(scl_id)
    )ENGINE=InnoDB;
"""

# 26
player_season_backboard_list = """
CREATE TABLE IF NOT EXISTS player_season_backboard_list(
    sbl_id  int  NOT NULL  AUTO_INCREMENT,
    sbl_name   varchar(50)  NOT NULL,
    sbl_match  varchar(20)  COMMENT '篮板榜比赛',
    sbl_score  varchar(10)  COMMENT '篮板榜个数',
    PRIMARY KEY(sbl_id)
    )ENGINE=InnoDB;
"""

# 27
player_season_assist_list = """
CREATE TABLE IF NOT EXISTS player_season_assist_list(
    sal_id  int  NOT NULL  AUTO_INCREMENT,
    sal_name  varchar(50)  NOT NULL,
    sal_match  varchar(20)  COMMENT '助攻榜比赛',
    sal_score  varchar(10)  COMMENT '助攻榜个数',
    PRIMARY KEY(sal_id)
    )ENGINE=InnoDB;
"""

# 28
player_season_cap_list = """
CREATE TABLE IF NOT EXISTS player_season_cap_list(
    scl_id  int  NOT NULL  AUTO_INCREMENT,
    scl_name  varchar(50)  NOT NULL,
    scl_match  varchar(20)  COMMENT '盖帽榜比赛',
    scl_score  varchar(10)  COMMENT '盖帽榜个数',
    PRIMARY KEY(scl_id)
    )ENGINE=InnoDB;
"""

# 29
player_season_steal_list = """
CREATE TABLE IF NOT EXISTS player_season_steal_list(
    ssl_id  int  NOT NULL  AUTO_INCREMENT,
    ssl_name  varchar(50)  NOT NULL,
    ssl_match  varchar(20)  COMMENT '抢断榜比赛',
    ssl_score  varchar(10)  COMMENT '抢断榜个数',
    PRIMARY KEY(ssl_id)
    )ENGINE=InnoDB;
"""

# 30
player_season_time_list = """
CREATE TABLE IF NOT EXISTS player_season_time_list(
    stl_id  int  NOT NULL  AUTO_INCREMENT,
    stl_name  varchar(50)  NOT NULL,
    stl_match  varchar(20)  COMMENT '出场时间榜比赛',
    stl_score  varchar(10)  COMMENT '出场时间榜时间',
    PRIMARY KEY(stl_id)
    )ENGINE=InnoDB;
"""

# 31
player_season_field_goal_list = """
CREATE TABLE IF NOT EXISTS player_season_field_goal_list(
    sfgl_id  int  NOT NULL  AUTO_INCREMENT,
    sfgl_name  varchar(50)  NOT NULL,
    sfgl_match  varchar(20)  COMMENT '投篮命中榜比赛',
    sfgl_score  varchar(10)  COMMENT '投篮命中榜个数',
    PRIMARY KEY(sfgl_id)
    )ENGINE=InnoDB;
"""

# 32
player_season_shoot_frequency_list = """
CREATE TABLE IF NOT EXISTS player_season_shoot_frequency_list(
    ssfl_id  int  NOT NULL  AUTO_INCREMENT,
    ssfl_name  varchar(50)  NOT NULL,
    ssfl_match  varchar(20)  COMMENT '投篮出手榜比赛',
    ssfl_score  varchar(10)  COMMENT '投篮出手榜个数',
    PRIMARY KEY(ssfl_id)
    )ENGINE=InnoDB;
"""

# 33
player_season_three_point_goal_list = """
CREATE TABLE IF NOT EXISTS player_season_three_point_goal_list(
    stpgl_id  int  NOT NULL  AUTO_INCREMENT,
    stpgl_name  varchar(50)  NOT NULL,
    stpgl_match  varchar(20)  COMMENT '三分命中榜比赛',
    stpgl_score  varchar(10)  COMMENT '三分命中榜个数',
    PRIMARY KEY(stpgl_id)
    )ENGINE=InnoDB;
"""

# 34
player_season_three_point_frequency_list = """
CREATE TABLE IF NOT EXISTS player_season_three_point_frequency_list(
    stpfl_id  int  NOT NULL  AUTO_INCREMENT,
    stpfl_name  varchar(50)  NOT NULL,
    stpfl_match  varchar(20)  COMMENT '三分出手榜比赛',
    stpfl_score  varchar(10)  COMMENT '三分出手榜个数',
    PRIMARY KEY(stpfl_id)
    )ENGINE=InnoDB;
"""

# 35
player_season_free_throw_goal_list = """
CREATE TABLE IF NOT EXISTS player_season_free_throw_goal_list(
    sftgl_id  int  NOT NULL  AUTO_INCREMENT,
    sftgl_name  varchar(50)  NOT NULL,
    sftgl_match  varchar(20)  COMMENT '罚球命中榜比赛',
    sftgl_score  varchar(10)  COMMENT '罚球命中榜个数',
    PRIMARY KEY(sftgl_id)
    )ENGINE=InnoDB;
"""

# 36
player_season_free_throw_frequency_list = """
CREATE TABLE IF NOT EXISTS player_season_free_throw_frequency_list(
    sftfl_id  int  NOT NULL  AUTO_INCREMENT,
    sftfl_name  varchar(50)  NOT NULL,
    sftfl_match  varchar(20)  COMMENT '罚球出手榜比赛',
    sftfl_score  varchar(10)  COMMENT '罚球出手榜个数',
    PRIMARY KEY(sftfl_id)
    )ENGINE=InnoDB;
"""

# 37
player_season_mistake_list = """
CREATE TABLE IF NOT EXISTS player_season_mistake_list(
    sml_id  int  NOT NULL  AUTO_INCREMENT,
    sml_name  varchar(50)  NOT NULL,
    sml_match  varchar(20)  COMMENT '失误榜比赛',
    sml_score  varchar(10)  COMMENT '失误榜次数',
    PRIMARY KEY(sml_id)
    )ENGINE=InnoDB;
"""

# 38
player_season_fouls_list = """
CREATE TABLE IF NOT EXISTS player_season_fouls_list(
    sfl_id  int  NOT NULL  AUTO_INCREMENT,
    sfl_name  varchar(50)  NOT NULL,
    sfl_match  varchar(20)  COMMENT '犯规榜比赛',
    sfl_score  varchar(10)  COMMENT '犯规榜次数',
    PRIMARY KEY(sfl_id)
    )ENGINE=InnoDB;
"""

# 39
player_season_undefined_list = """
CREATE TABLE IF NOT EXISTS player_season_undefined_list(
    sul_id  int  NOT NULL  AUTO_INCREMENT,
    sul_name  varchar(50)  NOT NULL,
    sul_match  varchar(20)  COMMENT '打铁榜比赛',
    sul_score  varchar(10)  COMMENT '打铁榜次数',
    PRIMARY KEY(sul_id)
    )ENGINE=InnoDB;
"""

# 40
player_playoff_score_list = """
CREATE TABLE IF NOT EXISTS player_playoff_score_list(
    pcl_id  int  NOT NULL    AUTO_INCREMENT,
    pcl_name  varchar(50)  NOT NULL,
    pcl_match  varchar(20)  COMMENT '得分榜比赛',
    pcl_score  varchar(10)  COMMENT '得分榜得分',
    PRIMARY KEY(pcl_id)
    )ENGINE=InnoDB;
"""

# 41
player_playoff_backboard_list = """
CREATE TABLE IF NOT EXISTS player_playoff_backboard_list(
    pbl_id  int  NOT NULL  AUTO_INCREMENT,
    pbl_name   varchar(50)  NOT NULL,
    pbl_match  varchar(20)  COMMENT '篮板榜比赛',
    pbl_score  varchar(10)  COMMENT '篮板榜个数',
    PRIMARY KEY(pbl_id)
    )ENGINE=InnoDB;
"""

# 42
player_playoff_assist_list = """
CREATE TABLE IF NOT EXISTS player_playoff_assist_list(
    pal_id  int  NOT NULL  AUTO_INCREMENT,
    pal_name  varchar(50)  NOT NULL,
    pal_match  varchar(20)  COMMENT '助攻榜比赛',
    pal_score  varchar(10)  COMMENT '助攻榜个数',
    PRIMARY KEY(pal_id)
    )ENGINE=InnoDB;
"""

# 43
player_playoff_cap_list = """
CREATE TABLE IF NOT EXISTS player_playoff_cap_list(
    pcl_id  int  NOT NULL  AUTO_INCREMENT,
    pcl_name  varchar(50)  NOT NULL,
    pcl_match  varchar(20)  COMMENT '盖帽榜比赛',
    pcl_score  varchar(10)  COMMENT '盖帽榜个数',
    PRIMARY KEY(pcl_id)
    )ENGINE=InnoDB;
"""

# 44
player_playoff_steal_list = """
CREATE TABLE IF NOT EXISTS player_playoff_steal_list(
    psl_id  int  NOT NULL  AUTO_INCREMENT,
    psl_name  varchar(50)  NOT NULL,
    psl_match  varchar(20)  COMMENT '抢断榜比赛',
    psl_score  varchar(10)  COMMENT '抢断榜个数',
    PRIMARY KEY(psl_id)
    )ENGINE=InnoDB;
"""

# 45
player_playoff_time_list = """
CREATE TABLE IF NOT EXISTS player_playoff_time_list(
    ptl_id  int  NOT NULL  AUTO_INCREMENT,
    ptl_name  varchar(50)  NOT NULL,
    ptl_match  varchar(20)  COMMENT '出场时间榜比赛',
    ptl_score  varchar(10)  COMMENT '出场时间榜时间',
    PRIMARY KEY(ptl_id)
    )ENGINE=InnoDB;
"""

# 46
player_playoff_field_goal_list = """
CREATE TABLE IF NOT EXISTS player_playoff_field_goal_list(
    pfgl_id  int  NOT NULL  AUTO_INCREMENT,
    pfgl_name  varchar(50)  NOT NULL,
    pfgl_match  varchar(20)  COMMENT '投篮命中榜比赛',
    pfgl_score  varchar(10)  COMMENT '投篮命中榜个数',
    PRIMARY KEY(pfgl_id)
    )ENGINE=InnoDB;
"""

# 47
player_playoff_shoot_frequency_list = """
CREATE TABLE IF NOT EXISTS player_playoff_shoot_frequency_list(
    psfl_id  int  NOT NULL  AUTO_INCREMENT,
    psfl_name  varchar(50)  NOT NULL,
    psfl_match  varchar(20)  COMMENT '投篮出手榜比赛',
    psfl_score  varchar(10)  COMMENT '投篮出手榜个数',
    PRIMARY KEY(psfl_id)
    )ENGINE=InnoDB;
"""

# 48
player_playoff_three_point_goal_list = """
CREATE TABLE IF NOT EXISTS player_playoff_three_point_goal_list(
    ptpgl_id  int  NOT NULL  AUTO_INCREMENT,
    ptpgl_name  varchar(50)  NOT NULL,
    ptpgl_match  varchar(20)  COMMENT '三分命中榜比赛',
    ptpgl_score  varchar(10)  COMMENT '三分命中榜个数',
    PRIMARY KEY(ptpgl_id)
    )ENGINE=InnoDB;
"""

# 49
player_playoff_three_point_frequency_list = """
CREATE TABLE IF NOT EXISTS player_playoff_three_point_frequency_list(
    ptpfl_id  int  NOT NULL  AUTO_INCREMENT,
    ptpfl_name  varchar(50)  NOT NULL,
    ptpfl_match  varchar(20)  COMMENT '三分出手榜比赛',
    ptpfl_score  varchar(10)  COMMENT '三分出手榜个数',
    PRIMARY KEY(ptpfl_id)
    )ENGINE=InnoDB;
"""

# 50
player_playoff_free_throw_goal_list = """
CREATE TABLE IF NOT EXISTS player_playoff_free_throw_goal_list(
    pftgl_id  int  NOT NULL  AUTO_INCREMENT,
    pftgl_name  varchar(50)  NOT NULL,
    pftgl_match  varchar(20)  COMMENT '罚球命中榜比赛',
    pftgl_score  varchar(10)  COMMENT '罚球命中榜个数',
    PRIMARY KEY(pftgl_id)
    )ENGINE=InnoDB;
"""

# 51
player_playoff_free_throw_frequency_list = """
CREATE TABLE IF NOT EXISTS player_playoff_free_throw_frequency_list(
    pftfl_id  int  NOT NULL  AUTO_INCREMENT,
    pftfl_name  varchar(50)  NOT NULL,
    pftfl_match  varchar(20)  COMMENT '罚球出手榜比赛',
    pftfl_score  varchar(10)  COMMENT '罚球出手榜个数',
    PRIMARY KEY(pftfl_id)
    )ENGINE=InnoDB;
"""

# 52
player_playoff_mistake_list = """
CREATE TABLE IF NOT EXISTS player_playoff_mistake_list(
    pml_id  int  NOT NULL  AUTO_INCREMENT,
    pml_name  varchar(50)  NOT NULL,
    pml_match  varchar(20)  COMMENT '失误榜比赛',
    pml_score  varchar(10)  COMMENT '失误榜次数',
    PRIMARY KEY(pml_id)
    )ENGINE=InnoDB;
"""

# 53
player_playoff_fouls_list = """
CREATE TABLE IF NOT EXISTS player_playoff_fouls_list(
    pfl_id  int  NOT NULL  AUTO_INCREMENT,
    pfl_name  varchar(50)  NOT NULL,
    pfl_match  varchar(20)  COMMENT '犯规榜比赛',
    pfl_score  varchar(10)  COMMENT '犯规榜次数',
    PRIMARY KEY(pfl_id)
    )ENGINE=InnoDB;
"""

# 54
player_playoff_undefined_list = """
CREATE TABLE IF NOT EXISTS player_playoff_undefined_list(
    pul_id  int  NOT NULL  AUTO_INCREMENT,
    pul_name  varchar(50)  NOT NULL,
    pul_match  varchar(20)  COMMENT '打铁榜比赛',
    pul_score  varchar(10)  COMMENT '打铁榜次数',
    PRIMARY KEY(pul_id)
    )ENGINE=InnoDB;
"""

# 55
player_personal_honor = """
CREATE TABLE IF NOT EXISTS player_personal_honor(
    ph_id  int  NOT NULL  AUTO_INCREMENT,
    ph_name  varchar(50)  NOT NULL,
    ph_season  varchar(20),
    ph_honor  varchar(50),
    PRIMARY KEY(ph_id)
    )ENGINE=InnoDB;
"""

# 56
player_salary_list = """
CREATE TABLE IF NOT EXISTS player_salary_list(
    sl_id  int  NOT NULL  AUTO_INCREMENT,
    sl_name  varchar(50)  NOT NULL,
    sl_season  varchar(10),
    sl_team  varchar(50),
    sl_salary  varchar(20),
    PRIMARY KEY(sl_id)
    )ENGINE=InnoDB;
"""

# 57
player_salary_total_list = """
CREATE TABLE IF NOT EXISTS player_salary_total_list(
    stl_id  int  NOT NULL  AUTO_INCREMENT,
    stl_name  varchar(50)  NOT NULL,
    stl_totalsalary  varchar(20),
    PRIMARY KEY(stl_id)
    )ENGINE=InnoDB;
"""

# 58
player_similar_players = """
CREATE TABLE IF NOT EXISTS player_similar_players(
    sp_id  int  NOT NULL  AUTO_INCREMENT,
    sp_name  varchar(50)  NOT NULL,
    sp_player  varchar(50),
    sp_avg_score  varchar(10)  COMMENT '生涯场均得分',
    sp_avg_backboard  varchar(10)  COMMENT '生涯场均篮板',
    sp_avg_assist  varchar(10)  COMMENT '生涯场均助攻',
    sp_avg_steal  varchar(10)  COMMENT '生涯场均抢断',
    sp_avg_cap  varchar(10)  COMMENT '生涯场均盖帽',
    PRIMARY KEY(sp_id)
    )ENGINE=InnoDB;
"""
